| lock_status | carrier | business_unit | sales_person | sku | quantity | order_type | first_time_customer | tgt_enc_sim_impt_x0 | unit_cost | model_family | tgt_enc_sim_impt_x2 | color | days_since_last_purchase | tgt_enc_sim_impt_x1 | memory_size | condition | channel | brand | unit_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 135.232066 | 137.595979 | 900.000000 | 149.058176 | 141.974257 | 100.000000 | 133.414677 | 0.000000 | 128.068295 | 160.490000 | 139.793592 | 142.455969 | 138.248964 | 0.000000 | 130.001970 | 110.841853 | 110.142066 | 132.120897 | 138.128169 | 170.000000 |
| 1 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 59.922031 | 20.000000 | 133.414677 | 0.000000 | 162.706079 | 62.999000 | 69.557337 | 78.996248 | 153.495556 | 0.000000 | 130.001970 | 72.018043 | 100.957235 | 132.120897 | 138.128169 | 55.000000 |
| 2 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 106.477876 | 1.000000 | 133.414677 | 0.000000 | 82.853069 | 68.086000 | 106.509901 | 105.995067 | 138.248964 | 0.000000 | 130.001970 | 84.349338 | 110.142066 | 132.120897 | 138.128169 | 110.000000 |
| 3 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 87.042071 | 8.000000 | 133.414677 | 0.000000 | 110.552115 | 58.136000 | 86.051424 | 81.791020 | 58.656957 | 0.000000 | 130.001970 | 110.841853 | 110.142066 | 132.120897 | 138.128169 | 88.000000 |
| 4 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 52.972789 | 2.000000 | 133.414677 | 0.000000 | 128.068295 | 37.691000 | 48.217918 | 57.046931 | 143.252723 | 0.000000 | 130.001970 | 72.018043 | 110.142066 | 132.120897 | 138.128169 | 51.000000 |
| lock_status | carrier | business_unit | sales_person | sku | quantity | order_type | first_time_customer | tgt_enc_sim_impt_x0 | unit_cost | model_family | tgt_enc_sim_impt_x2 | color | days_since_last_purchase | tgt_enc_sim_impt_x1 | memory_size | condition | channel | brand | unit_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139842 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 156.222221 | 4.000000 | 133.414677 | 0.000000 | 162.706079 | 153.000000 | 137.066068 | 141.795103 | 148.029814 | 0.000000 | 130.001970 | 84.349338 | 231.236690 | 132.120897 | 138.128169 | 160.000000 |
| 139843 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 137.783282 | 1.000000 | 133.414677 | 0.000000 | 128.068295 | 97.006000 | 145.785332 | 142.455969 | 138.248964 | 0.000000 | 130.001970 | 155.582144 | 120.342959 | 132.120897 | 138.128169 | 130.000000 |
| 139844 | 135.232066 | 137.595979 | 900.000000 | 149.058176 | 96.274460 | 1.000000 | 133.414677 | 0.000000 | 162.706079 | 125.999000 | 142.682683 | 163.237457 | 138.248964 | 0.000000 | 130.001970 | 110.841853 | 100.957235 | 132.120897 | 138.128169 | 90.000000 |
| 139845 | 135.232066 | 137.595979 | 900.000000 | 119.852983 | 31.300885 | 1.000000 | 133.414677 | 0.000000 | 82.853069 | 25.000000 | 34.077742 | 33.074447 | 153.495556 | 0.000000 | 130.001970 | 84.349338 | 110.142066 | 132.120897 | 138.128169 | 35.000000 |
| 139846 | 135.232066 | 92.100800 | 900.000000 | 119.852983 | 109.477298 | 1.000000 | 133.414677 | 0.000000 | 128.068295 | 78.277000 | 113.284406 | 89.452952 | 148.029814 | 0.000000 | 130.001970 | 179.528718 | 120.342959 | 90.690402 | 138.128169 | 105.000000 |
No missing values in data
No Infinity values
No Missing Values
No duplicate variables
| N | < (mean-3*std) | > (mean+3*std) | < (1stQ - 1.5 * IQR) | > (3rdQ + 1.5 * IQR) | -inf | +inf | |
|---|---|---|---|---|---|---|---|
| Feature | |||||||
| lock_status | 139847 | 158 | 0 | 158 | 4657 | 0 | 0 |
| carrier | 139847 | 5476 | 1963 | 9029 | 1963 | 0 | 0 |
| business_unit | 139847 | 7257 | 0 | 8515 | 8822 | 0 | 0 |
| sales_person | 139847 | 0 | 743 | 6 | 5702 | 0 | 0 |
| sku | 139847 | 0 | 2930 | 0 | 11243 | 0 | 0 |
| quantity | 139847 | 3 | 2357 | 169 | 15321 | 0 | 0 |
| order_type | 139847 | 0 | 4040 | 0 | 4040 | 0 | 0 |
| first_time_customer | 139847 | 0 | 4281 | 0 | 4281 | 0 | 0 |
| tgt_enc_sim_impt_x0 | 139847 | 2266 | 0 | 2266 | 0 | 0 | 0 |
| unit_cost | 139847 | 0 | 3506 | 0 | 8502 | 0 | 0 |
| model_family | 139847 | 0 | 2898 | 0 | 10368 | 0 | 0 |
| tgt_enc_sim_impt_x2 | 139847 | 0 | 2742 | 0 | 9948 | 0 | 0 |
| color | 139847 | 442 | 2618 | 10700 | 4853 | 0 | 0 |
| days_since_last_purchase | 139847 | 0 | 1743 | 0 | 2372 | 0 | 0 |
| tgt_enc_sim_impt_x1 | 139847 | 0 | 10447 | 0 | 13543 | 0 | 0 |
| memory_size | 139847 | 0 | 8094 | 0 | 8094 | 0 | 0 |
| condition | 139847 | 0 | 1210 | 222 | 1210 | 0 | 0 |
| channel | 139847 | 0 | 2674 | 9216 | 6247 | 0 | 0 |
| brand | 139847 | 5604 | 0 | 5604 | 0 | 0 | 0 |
| unit_price | 139847 | 0 | 2853 | 0 | 10408 | 0 | 0 |
| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | brand | float64 | 2 | [138.12816902184844, 89.490665064904] | 136.179149 | 9.539257 | 89.490665 | 138.128169 | 138.128169 | 138.128169 | 138.128169 |
| 1 | business_unit | float64 | 10 | [900.0, 904.0, 922.0, 480.32456422234065, 700.0] | 876.751553 | 96.450346 | 480.324564 | 900.000000 | 900.000000 | 900.000000 | 935.000000 |
| 2 | carrier | float64 | 8 | [137.59597888324086, 177.39227812657035, 93.08839858691479, 102.37927751834557, 97.88573248407643] | 135.498681 | 11.327105 | 93.088399 | 137.595979 | 137.595979 | 137.595979 | 177.392278 |
| 3 | channel | float64 | 10 | [132.12089741445845, 90.69040233666061, 146.6541923213651, 253.23132451965603, 81.386081300813] | 132.367100 | 20.648167 | 68.406667 | 132.120897 | 132.120897 | 132.120897 | 253.231325 |
| 4 | color | float64 | 30 | [138.2489639738742, 153.49555624450124, 58.65695707295374, 143.25272264133372, 103.57299342820437] | 134.451534 | 33.019880 | 25.816035 | 120.758911 | 143.252723 | 148.029814 | 244.667803 |
| 5 | condition | float64 | 21 | [110.1420661978082, 100.95723477538753, 120.34295941861212, 202.48760250482823, 195.4376402502607] | 134.586005 | 42.791594 | 7.664739 | 110.142066 | 110.142066 | 165.638901 | 272.005940 |
| 6 | days_since_last_purchase | float64 | 3 | [0.0, 1.8959041358031585, 1.0] | 0.028128 | 0.220243 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.895904 |
| 7 | first_time_customer | float64 | 2 | [0.0, 0.29965361163909293] | 0.009173 | 0.051620 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.299654 |
| 8 | lock_status | float64 | 3 | [135.23206602138754, 137.17599248443202, 129.99489380266414] | 135.290883 | 0.391623 | 129.994894 | 135.232066 | 135.232066 | 135.232066 | 137.175992 |
| 9 | memory_size | float64 | 11 | [110.84185308027186, 72.01804319654427, 84.34933772269558, 179.52871822004528, 155.5821439437734] | 134.165864 | 64.151608 | 23.378892 | 84.349338 | 110.841853 | 155.582144 | 338.974196 |
| 10 | model_family | float64 | 183 | [139.79359246088194, 69.55733681145352, 106.50990083905417, 86.0514243792325, 48.217917996870106] | 132.820228 | 95.165548 | 8.369396 | 69.557337 | 98.612845 | 156.515299 | 451.812826 |
| 11 | order_type | float64 | 2 | [133.41467696068688, 167.0326171114319] | 134.385856 | 5.630815 | 133.414677 | 133.414677 | 133.414677 | 133.414677 | 167.032617 |
| 12 | quantity | float64 | 171 | [100.0, 20.0, 1.0, 8.0, 2.0] | 8.822181 | 20.775175 | -107.054555 | 1.000000 | 2.000000 | 7.000000 | 129.699468 |
| 13 | sales_person | float64 | 13 | [149.05817598516106, 119.85298332309411, 145.4403729333729, 216.8189755122439, 210.42307692307693] | 134.679332 | 24.201388 | 70.436637 | 119.852983 | 119.852983 | 149.058176 | 221.810979 |
| 14 | sku | float64 | 5730 | [141.9742571428571, 59.92203050847458, 106.47787610619469, 87.042071197411, 52.97278911564626] | 132.002543 | 94.591170 | 5.322033 | 65.631579 | 106.265851 | 157.846154 | 446.975274 |
| 15 | tgt_enc_sim_impt_x0 | float64 | 6 | [128.0682946896036, 162.70607912677693, 82.85306886929344, 110.55211495629797, 171.44040834473324] | 135.279436 | 26.600705 | 55.069065 | 128.068295 | 128.068295 | 162.706079 | 171.440408 |
| 16 | tgt_enc_sim_impt_x1 | float64 | 4 | [130.0019700247023, 188.21983426727854, 139.89883877221325, 135.23926336639326] | 134.570091 | 15.313211 | 130.001970 | 130.001970 | 130.001970 | 130.001970 | 188.219834 |
| 17 | tgt_enc_sim_impt_x2 | float64 | 166 | [142.45596918511757, 78.99624829584185, 105.99506735751297, 81.79102022315203, 57.04693107344633] | 132.572601 | 89.141895 | 7.369442 | 79.315704 | 96.965945 | 160.409558 | 437.301406 |
| 18 | unit_cost | float64 | 39859 | [160.49, 62.999, 68.086, 58.136, 37.691] | 108.112298 | 83.779436 | 0.000000 | 49.865000 | 80.354000 | 139.534500 | 370.983182 |
| 19 | unit_price | float64 | 1800 | [170.0, 55.0, 110.0, 88.0, 51.0] | 135.239263 | 112.507163 | 0.000000 | 63.659000 | 100.000000 | 165.000000 | 1159.000000 |
No categorical columns
No categorical variables in data.
| Variable 1 | Variable 2 | Corr Coef | Abs Corr Coef | |
|---|---|---|---|---|
| 0 | sku | unit_price | 0.924854 | 0.924854 |
| 1 | unit_price | sku | 0.924854 | 0.924854 |
| 2 | model_family | unit_price | 0.919086 | 0.919086 |
| 3 | unit_price | model_family | 0.919086 | 0.919086 |
| 4 | unit_price | tgt_enc_sim_impt_x2 | 0.873985 | 0.873985 |
| 5 | tgt_enc_sim_impt_x2 | unit_price | 0.873985 | 0.873985 |
| 6 | unit_price | unit_cost | 0.867702 | 0.867702 |
| 7 | unit_cost | unit_price | 0.867702 | 0.867702 |
| 8 | unit_price | memory_size | 0.600660 | 0.600660 |
| 9 | memory_size | unit_price | 0.600660 | 0.600660 |
| 10 | unit_price | condition | 0.399041 | 0.399041 |
| 11 | condition | unit_price | 0.399041 | 0.399041 |
| 12 | channel | unit_price | 0.332982 | 0.332982 |
| 13 | unit_price | channel | 0.332982 | 0.332982 |
| 14 | unit_price | color | 0.318499 | 0.318499 |
| 15 | color | unit_price | 0.318499 | 0.318499 |
| 16 | tgt_enc_sim_impt_x0 | unit_price | 0.237512 | 0.237512 |
| 17 | unit_price | tgt_enc_sim_impt_x0 | 0.237512 | 0.237512 |
| 18 | sales_person | unit_price | 0.233028 | 0.233028 |
| 19 | unit_price | sales_person | 0.233028 | 0.233028 |
| 20 | tgt_enc_sim_impt_x1 | unit_price | 0.156956 | 0.156956 |
| 21 | unit_price | tgt_enc_sim_impt_x1 | 0.156956 | 0.156956 |
| 22 | brand | unit_price | 0.125676 | 0.125676 |
| 23 | unit_price | brand | 0.125676 | 0.125676 |
| 24 | quantity | unit_price | 0.124464 | 0.124464 |
| 25 | unit_price | quantity | 0.124464 | 0.124464 |
| 26 | unit_price | carrier | 0.122385 | 0.122385 |
| 27 | carrier | unit_price | 0.122385 | 0.122385 |
| 28 | unit_price | business_unit | -0.095195 | 0.095195 |
| 29 | business_unit | unit_price | -0.095195 | 0.095195 |
| 30 | unit_price | order_type | 0.094028 | 0.094028 |
| 31 | order_type | unit_price | 0.094028 | 0.094028 |
| 32 | unit_price | first_time_customer | 0.070741 | 0.070741 |
| 33 | first_time_customer | unit_price | 0.070741 | 0.070741 |
| 34 | unit_price | days_since_last_purchase | 0.061948 | 0.061948 |
| 35 | days_since_last_purchase | unit_price | 0.061948 | 0.061948 |
| 36 | unit_price | lock_status | 0.009686 | 0.009686 |
| 37 | lock_status | unit_price | 0.009686 | 0.009686 |